Create ODS Layer Database

The following steps will help you to create an ODS database.

  1. Open Microsoft SQL Server Management Studio.
  2. Right Click on Database ==> Click on New Database.
  3. New Database dialog box appears ==> Then, give a name for your new database.
  4. Click Ok to create a new database.
  5. Click on the plus sign next to the database on object explorer ==> Located newly created database. If you don't see the newly created database, then Right Click on database ==> Click on refresh from the popup dialog box.





*Create Dictionary Tables in ODS Database

Download the SQL file attached above  

Dictionary_Incident_Location

Dictionary_Incident_Place

Dictionary_Shooter

Dictionary_Shooter_History_Of_Mental_Illness

dbo].[Dictionary_Shooter_Status

dbo].[Dictionary_Shooters_Motive

Dictionary_Trageted_Victim

Dictionary_Weapons

tbl_Mass_Shooting_ODS











https://www.youtube.com/watch?v=5nfHmh8NsHw&t=179s